In [1]:
import pandas as pd
In [2]:
import numpy as np
In [3]:
import pandas_profiling.model.pandas
In [4]:
df=pd.read_csv("data.csv.zip")
In [5]:
df.head()
Out[5]:
valence year acousticness artists danceability duration_ms energy explicit id instrumentalness key liveness loudness mode name popularity release_date speechiness tempo
0 0.0594 1921 0.982 ['Sergei Rachmaninoff', 'James Levine', 'Berli... 0.279 831667 0.211 0 4BJqT0PrAfrxzMOxytFOIz 0.878000 10 0.665 -20.096 1 Piano Concerto No. 3 in D Minor, Op. 30: III. ... 4 1921 0.0366 80.954
1 0.9630 1921 0.732 ['Dennis Day'] 0.819 180533 0.341 0 7xPhfUan2yNtyFG0cUWkt8 0.000000 7 0.160 -12.441 1 Clancy Lowered the Boom 5 1921 0.4150 60.936
2 0.0394 1921 0.961 ['KHP Kridhamardawa Karaton Ngayogyakarta Hadi... 0.328 500062 0.166 0 1o6I8BglA6ylDMrIELygv1 0.913000 3 0.101 -14.850 1 Gati Bali 5 1921 0.0339 110.339
3 0.1650 1921 0.967 ['Frank Parker'] 0.275 210000 0.309 0 3ftBPsC5vPBKxYSee08FDH 0.000028 5 0.381 -9.316 1 Danny Boy 3 1921 0.0354 100.109
4 0.2530 1921 0.957 ['Phil Regan'] 0.418 166693 0.193 0 4d6HGyGT8e121BsdKmw9v6 0.000002 3 0.229 -10.096 1 When Irish Eyes Are Smiling 2 1921 0.0380 101.665
In [6]:
!pip install https://github.com/pandas-profiling/pandas-profiling/archive/master.zip
Collecting https://github.com/pandas-profiling/pandas-profiling/archive/master.zip
  Using cached https://github.com/pandas-profiling/pandas-profiling/archive/master.zip (21.9 MB)
  Preparing metadata (setup.py): started
  Preparing metadata (setup.py): finished with status 'done'
Requirement already satisfied: joblib~=1.1.0 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (1.1.0)
Requirement already satisfied: scipy>=1.4.1 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (1.7.3)
Requirement already satisfied: pandas!=1.0.0,!=1.0.1,!=1.0.2,!=1.1.0,>=0.25.3 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (1.4.2)
Requirement already satisfied: matplotlib>=3.2.0 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (3.5.1)
Requirement already satisfied: pydantic>=1.8.1 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (1.9.1)
Requirement already satisfied: PyYAML>=5.0.0 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (6.0)
Requirement already satisfied: jinja2>=2.11.1 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (2.11.3)
Requirement already satisfied: visions[type_image_path]==0.7.5 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (0.7.5)
Requirement already satisfied: numpy>=1.16.0 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (1.21.5)
Requirement already satisfied: htmlmin>=0.1.12 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (0.1.12)
Requirement already satisfied: missingno>=0.4.2 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (0.5.1)
Requirement already satisfied: phik>=0.11.1 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (0.12.2)
Requirement already satisfied: tangled-up-in-unicode==0.2.0 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (0.2.0)
Requirement already satisfied: requests>=2.24.0 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (2.27.1)
Requirement already satisfied: tqdm>=4.48.2 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (4.64.0)
Requirement already satisfied: seaborn>=0.10.1 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (0.11.2)
Requirement already satisfied: multimethod>=1.4 in c:\users\manee\anaconda3\lib\site-packages (from pandas-profiling==3.2.0) (1.8)
Requirement already satisfied: networkx>=2.4 in c:\users\manee\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->pandas-profiling==3.2.0) (2.7.1)
Requirement already satisfied: attrs>=19.3.0 in c:\users\manee\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->pandas-profiling==3.2.0) (21.4.0)
Requirement already satisfied: imagehash in c:\users\manee\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->pandas-profiling==3.2.0) (4.2.1)
Requirement already satisfied: Pillow in c:\users\manee\anaconda3\lib\site-packages (from visions[type_image_path]==0.7.5->pandas-profiling==3.2.0) (9.0.1)
Requirement already satisfied: MarkupSafe>=0.23 in c:\users\manee\anaconda3\lib\site-packages (from jinja2>=2.11.1->pandas-profiling==3.2.0) (2.1.1)
Requirement already satisfied: kiwisolver>=1.0.1 in c:\users\manee\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling==3.2.0) (1.3.2)
Requirement already satisfied: fonttools>=4.22.0 in c:\users\manee\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling==3.2.0) (4.25.0)
Requirement already satisfied: pyparsing>=2.2.1 in c:\users\manee\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling==3.2.0) (3.0.4)
Requirement already satisfied: packaging>=20.0 in c:\users\manee\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling==3.2.0) (21.3)
Requirement already satisfied: cycler>=0.10 in c:\users\manee\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling==3.2.0) (0.11.0)
Requirement already satisfied: python-dateutil>=2.7 in c:\users\manee\anaconda3\lib\site-packages (from matplotlib>=3.2.0->pandas-profiling==3.2.0) (2.8.2)
Requirement already satisfied: pytz>=2020.1 in c:\users\manee\anaconda3\lib\site-packages (from pandas!=1.0.0,!=1.0.1,!=1.0.2,!=1.1.0,>=0.25.3->pandas-profiling==3.2.0) (2021.3)
Requirement already satisfied: typing-extensions>=3.7.4.3 in c:\users\manee\anaconda3\lib\site-packages (from pydantic>=1.8.1->pandas-profiling==3.2.0) (4.1.1)
Requirement already satisfied: charset-normalizer~=2.0.0 in c:\users\manee\anaconda3\lib\site-packages (from requests>=2.24.0->pandas-profiling==3.2.0) (2.0.4)
Requirement already satisfied: urllib3<1.27,>=1.21.1 in c:\users\manee\anaconda3\lib\site-packages (from requests>=2.24.0->pandas-profiling==3.2.0) (1.26.9)
Requirement already satisfied: certifi>=2017.4.17 in c:\users\manee\anaconda3\lib\site-packages (from requests>=2.24.0->pandas-profiling==3.2.0) (2022.6.15)
Requirement already satisfied: idna<4,>=2.5 in c:\users\manee\anaconda3\lib\site-packages (from requests>=2.24.0->pandas-profiling==3.2.0) (3.3)
Requirement already satisfied: colorama in c:\users\manee\anaconda3\lib\site-packages (from tqdm>=4.48.2->pandas-profiling==3.2.0) (0.4.4)
Requirement already satisfied: six>=1.5 in c:\users\manee\anaconda3\lib\site-packages (from python-dateutil>=2.7->matplotlib>=3.2.0->pandas-profiling==3.2.0) (1.16.0)
Requirement already satisfied: PyWavelets in c:\users\manee\anaconda3\lib\site-packages (from imagehash->visions[type_image_path]==0.7.5->pandas-profiling==3.2.0) (1.3.0)
In [9]:
from pandas_profiling import ProfileReport
In [11]:
profile = ProfileReport(df,title="data analysis",html={ "style":{"ful_width":True}})
#profile.to_file(output_file="data analysis.html")
In [12]:
profile
Summarize dataset:   0%|          | 0/5 [00:00<?, ?it/s]
Generate report structure:   0%|          | 0/1 [00:00<?, ?it/s]
Render HTML:   0%|          | 0/1 [00:00<?, ?it/s]
Out[12]:

In [ ]: